Introduction to and Applications of PowerBI
Enrolled You have 10 weeks remaining for the course
DESCRIPTION
Provide a jump start for Data Analysts or Information Technology staff interested in using Power BI for Business Intelligence or Operational Reporting. The class covers all necessary topics needed to read data from multiple sources, generate a useful data model and publish a functional dashboards to the cloud. The class will also provide an overview of how to solve common business problem using Power BI techniques, including common reporting metrics like weighted averages, moving averages, Year to Date and Year over Year calculations.
TARGET AUDIENCE
- Data Analysts
- Business Analysts
- Information Technology / Business Intelligence Professionals
OBJECTIVES
At the end of this course, students will be able to:
- Extract data from relational databases, OData, Bid Data (Hadoop), SharePoint Lists or cloud sources
- Perform transformations on data (common examples are removing duplicates, splitting columns, pivoting data, etc.)
- Create a data model to support multiple reporting views
- Create business calculations in Power BI’s formula language
- Create interactive reports/dashboards
- Publish reports/dashboards and share them with others
- Power BI overview
- Power BI versus Excel Reporting
- Cloud vs On‐Prem Reporting
- Introduction to Power Query
- Introduction to the M language
- Power Query Transformations
- Introduction to Power Pivot
- Introduction to the DAX language
- Query context and the CALCULATE function
- Introduction to Power View / Power BI reporting
- Differences between Excel / Power BI Desktop
- Building a Report
- Custom Visuals
- Power Query Functions
- Consuming Web sources in Power Query
- Shaping Data Models in Power Query
- Creating Business calculations: DAX Filter Context
- Time Intelligence calculations
- Publishing to Power BI cloud service
- Creating a Dashboard
- Power BI Q&A – Natural Language
- Mobile Consumption
- Using the Personal Gateway
- “Bring your own data”
- Data profiling using Power Query/Power Pivot
- Building the ideal data model for the specified Subject Area
- Custom functions/transforms in Power Query
- Custom business calculations in DAX/Power Pivot
- Building a Power BI dashboard for the specified Subject Area
- Publishing to Power BI
- Create a working sample of an actual report
You May Like
Python for Data Science & Machine Learning – Certification Boot Camp
DESCRIPTIONProvide a jump start for Data Analysts or Information Technology staff interested in using Power BI for Business Intelligence or Operational Reporting. The class covers all necessary topics needed to read data from multiple sources, generate a useful data model and publish a functional dashboards to the cloud. The class will also provide an overview of how to solve common
More DetailsEnquire Now
Immersion Certification in Continuous Integration and Development Tools
DESCRIPTIONProvide a jump start for Data Analysts or Information Technology staff interested in using Power BI for Business Intelligence or Operational Reporting. The class covers all necessary topics needed to read data from multiple sources, generate a useful data model and publish a functional dashboards to the cloud. The class will also provide an overview of how to solve common
More DetailsEnquire Now
Azure Cloud Architect Immersion Certification Program
DESCRIPTIONProvide a jump start for Data Analysts or Information Technology staff interested in using Power BI for Business Intelligence or Operational Reporting. The class covers all necessary topics needed to read data from multiple sources, generate a useful data model and publish a functional dashboards to the cloud. The class will also provide an overview of how to solve common
More DetailsEnquire Now