BUSINESS INTELLIGENCE COURSE WITH POWER BI
objective
At the end of the course, the participant will be able to develop reports, visualizations and dashboards with Power BI, importing and relating data from different sources and being able to perform data manipulation, indicator calculations, use of the app store and connection to R.
Content
1. Introduction to Business Intelligence and Power BI
to. Key concepts in Business Intelligence
b. Download and Install Power BI Desktop
c. What is Power BI Desktop, mobile, Embedded, Power BI Pro, Premium, Power BI Report Server, Power BI service cloud
2. Power BI + Excel
to. From Power Pivot and Power View to Power BI
3. Import, data preparation
to. Connecting to a wide variety of cloud and local data sources
b. Query Editor (Power Query Editor):
i. Enter Data, Manage Parameters, columns and rows
ii. Combine data: Merge Queries, Append Queries
iii. Debugging and Data Transformations
c. Extract vs Direct Query
d. Personal gateway
4. Data Modeling panel
to. Manage tables and relationships
b. Manage roles
5. Panel Data and Fields
to. Create tables and columns
b. Time dimensions
c. Create calculated dimensions and measures
d. Create quick measure
and. Hierarchies
6. Use of DAX Functions (Data Analysis Expressions)
to. Introduction to DAX
b. DAX functions
c. DAX variables and expressions
d. DAX relationships
and. Filtering and DAX tables
7. Reports and Visualizations Panel
to. Simple graphics
b. Tables and matrices
c. Parameters
d. Combined graphics
and. Segmentation
F. Maps
g. Interactions between visualization
h. Import from Marketplace
i. Integrate R with Power BI
8. Reports and dashboards
to. Generate reports and dashboards
b. Filters
9. Publishing and sharing
to. Content packages
b. Publish Power BI Desktop reports to Power BI pro
c. Print or export reports or dashboards
d. Power BI mobile layout
and. Publish to web