55163AC : Preparing Your Data for Power BI
- Duration: 2 Days (16 Hours)
Highlights
- Microsoft Partner
- Practice Labs
- Microsoft Certified Trainers
- Digital Courseware
- Access to the Recordings
- Experience 24*7 Learner Support.
Enquire Now
55163AC : Preparing Your Data for Power BI Course Overview:
This 55163AC : Preparing Your Data for Power BI course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.
Audience Profile:
The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.
At Course Completion:
- Understand Analysis Services Installation and Architecture: One Product, Two Models.
- Understand version changes: SQL Server Analysis Services.
- Understand important terms.
- Understand and utilize SQL Server Data Tools for Tabular.
- Understand and utilize projects.
- Understand and utilize importing.
- Understand and utilize loading data.
- Understand and utilize examining views.
- Understand and utilize deployment.
- Understand and utilize data sources.
- Understand and utilize data credentials.
- Understand and utilize SQL as a source.
- Understand and utilize Excel as a source.
- Understand and utilize Flat Files as a source.
- Understand and utilize Azure as a source.
- Understand and utilize SharePoint as a source.
- Understand and utilize sorting during load.
- Understand querying with MDX.
- Understand and utilize DAX syntax.
- Understand and utilize DAX data types and operator overloading.
- Understand and utilize DAX operators.
- Understand and utilize DAX values.
- Understand and utilize measures.
- Understand and utilize calculated columns.
- Understand evaluation contexts.
- Understand and utilize date calculations.
- Understand and utilize importing related tables.
- Understand and utilize creating relationships.
- Understand and utilize hierarchies.
- Understand Direct Query.
- Understand and utilize KPIs.
- Understand drillthrough.
- Understand perspectives.
- Understand and utilize PowerPivot.
- Understand and utilze Pivot Tables.
- Understand and utilize Power View.
Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We’ll Be Discussing
Lab 1: Course Overview
- None
After completing this module, students will be able to:
- Successfully log into their virtual machine.
- Have a full understanding of what the course intends to cover.
Module 2: What is the Tabular Model?
SQL Server Analysis Services (SSAS) provides two different approaches for data modeling: multidimensional and tabular. While there is substantial overlap between them, there are also significant differences. In this module, we discuss feature comparisons and explain each approach, then we’ll dive deeper into the tabular model as that is the focus for this course.
Lessons
- Analysis Services Installation and Architecture: One Product, Two Models
- Version Changes: SQL Server Analysis Services
- Important Terms
- SQL Server Data Tools for Tabular
Lab 1: What is the Tabular Model?
- SQL Server Data Tools for Tabular
After completing this module, students will be able to:
- Understand Analysis Services Installation and Architecture: One Product, Two Models.
- Understand version changes: SQL Server Analysis Services.
- Understand important terms.
- Understand and utilize SQL Server Data Tools for Tabular.
Module 3: Working in Tabular
In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.
Lessons
- Projects
- Importing
- Loading Data
- Examining Views
- Deployment
Lab 1: Working in Tabular
- Creating a Tabular Project
Module 4: Working in Tabular
After completing this module, students will be able to:
- Understand and utilize projects.
- Understand and utilize importing.
- Understand and utilize loading data.
- Understand and utilize examining views.
- Understand and utilize deployment.
Module 5: Understanding Loading Data From Different Sources
In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.
Lessons
- Data Sources
- Data Credentials
- SQL as a Source
- Excel as a Source
- Flat Files as a Source
- Azure as a Source
- SharePoint as a Source
- Sorting During Load
Lab 1: Understanding Loading Data From Different Sources
- None
After completing this module, students will be able to:
- Understand and utilize data sources.
- Understand and utilize data credentials.
- Understand and utilize SQL as a source.
- Understand and utilize Excel as a source.
- Understand and utilize Flat Files as a source.
- Understand and utilize Azure as a source.
- Understand and utilize SharePoint as a source.
- Understand and utilize sorting during load.
Module 6: Using DAX and MDX
In this module, we will discuss two different languages; DAX and MDX. We will briefly explore MDX and its use with a tabular model, then we’ll cover DAX and walk-through how to use this powerful language.
Lessons
- Querying with MDX
- Basic DAX Syntax
- Evaluation Context
- Calculate Function
- Time Intelligence
Lab 1: Using DAX and MDX
- DAX Syntax
- DAX Data Types and Operator Overloading
- DAX Operators
- DAX Values
- Measures
- Calculated Columns
- Evaluation Contexts
- Date Calculations
After completing this module, students will be able to:
- Understand querying with MDX.
- Understand and utilize DAX syntax.
- Understand and utilize DAX data types and operator overloading.
- Understand and utilize DAX operators.
- Understand and utilize DAX values.
- Understand and utilize measures.
- Understand and utilize calculated columns.
- Understand evaluation contexts.
- Understand and utilize date calculations.
Module 7: Building Data Models
In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.
Lessons
- Importing Related Tables
- Creating Relationships
- Hierarchies
- Direct Query
- KPIs
- Drillthrough
- Perspectives
Lab 1: Building Data Models
- Creating Relationships
- Hierarchies
After completing this module, students will be able to:
Lessons
- Understand and utilize importing related tables.
- Understand and utilize creating relationships.
- Understand and utilize hierarchies.
- Understand Direct Query.
- Understand and utilize KPIs.
- Understand drillthrough.
- Understand perspectives.
Module 8: Excel PowerPivot and Tabular
In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.
Lessons
- Working with PowerPivot
- Working with Pivot Tables
- Working with PowerView
Lab 1: Excel PowerPivot and Tabular
- Importing Data
- Importing Large Datasets
- Importing Data with a Query
- Creating Relationships
- Creating a Cascading Relationship
- Power View
After completing this module, students will be able to:
- Understand and utilize PowerPivot.
- Understand and utilze Pivot Tables.
- Understand and utilize Power View.
55163AC : Preparing Your Data for Power BI Course Prerequisites:
A working knowledge of SQL Server
Q: What is the 55163AC: Preparing Your Data for Power BI training?
A: The 55163AC: Preparing Your Data for Power BI training is a specialized program designed to provide participants with the knowledge and skills required to prepare and transform data for effective use in Power BI. The training covers various data preparation techniques, best practices, and tools that enable users to clean, shape, and enhance data to optimize its visualization and analysis in Power BI.
Q: Who should consider taking the 55163AC: Preparing Your Data for Power BI training?
A: This training is ideal for data analysts, business intelligence professionals, and individuals responsible for data preparation and modeling for Power BI. It is suitable for participants who have a basic understanding of Power BI and want to enhance their skills in data preparation to ensure accurate and meaningful insights from their data.
Q: What topics are covered in the 55163AC: Preparing Your Data for Power BI training?
A: The training covers a range of topics, including data preparation best practices, data cleaning and transformation techniques, using Power Query to shape and refine data, working with relationships and data models in Power BI, optimizing data for performance, and troubleshooting common data preparation issues.
Q: Do I need any prior experience with Power BI or data preparation to attend the 55163AC: Preparing Your Data for Power BI training?
A: It is recommended to have a basic understanding of Power BI and its functionalities before attending this training. Familiarity with data concepts and basic data manipulation techniques will also be beneficial. However, the training is designed to cater to participants with varying levels of experience in both Power BI and data preparation.
Q: How can the 55163AC: Preparing Your Data for Power BI training benefit my career?
A: The training equips you with the skills and techniques necessary to efficiently prepare and transform data for Power BI. By mastering data cleaning, shaping, and modeling, you can ensure accurate and reliable insights in your Power BI reports and dashboards. This proficiency in data preparation is highly valued in the business intelligence field and can enhance your career prospects as a data analyst or BI professional.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Don’t Just Take Our Word for It
Read what our satisfied clients have to say about their transformative experiences
Got more questions? We’re all ears and ready to assist!