HomeCoursesBusiness Intelligence & Data Warehousing with Microsoft Power BIBy Ekton Project Analytics / April 18, 2023 Course InformationEstimated Time: 60 hoursDifficulty: AdvancedCategories: Business Intelligence, Project ManagementTags: business intelligence, data, management, warehouse Business Intelligence & Data Warehousing course $250.00Introduction to Data Warehousing and Business Intelligence Understand the concepts of Data Warehousing and Business Intelligence Understand the benefits of using Business Intelligence for making informed decisions Understand how businesses can use Business Intelligence to improve their performance Designing the Database for a Data Warehouse Understand the principles of data modeling for the data warehouse Understand the design of a star or snowflake schema for the data warehouse Understand how to design fact tables and dimension tables Understand how to establish relationships between tables Extract, Transform, and Load (ETL) Understand the ETL processes Understand how to extract data from different sources Understand how to transform data to fit the structure of the data warehouse Understand how to load data into the data warehouse Creating Reports with Microsoft Power BI Understand the basic concepts of Power BI Understand how to connect to data sources Understand how to create data visualizations Understand how to create interactive dashboards Advanced Use of Power BI Understand how to create measures and key performance indicators (KPIs) Understand how to use DAX functions to create custom calculations Understand how to use hierarchy and filter functions to refine data visualizations Deployment and Maintenance of the Data Warehouse and Power BI Reports Understand the deployment processes for the data warehouse and Power BI reports Understand how to manage updates and maintenance for the data warehouse and Power BI reports Understand how to manage security and permissions for access to the data warehouse and Power BI reports
