Select Page

Microsoft Specialist. Business Intelligence Power BI

The development of technologies and society is promoting the emergence of new professions.

One of the new specializations is in the Business Intelligence sector. Experts in this field are essential for companies, as they are responsible for organizing and managing the company's products and data. We offer training on different data analysis technologies and methodologies, integrating them to develop the analytical skills necessary to effectively extract and evaluate data, as a tool for improving company decision-making.

REQUEST MORE INFORMATION

     

    Do you want to see a demo class?

      Demo Video
      Infórmate Infórmate

      About the Microsoft Business Intelligence Power BI Specialist course

      In this practical 100% course, you'll learn everything related to creating interactive dashboards with easy table management and handling through both a visual interface and code. You'll learn SQL and DAX languages, as well as components like Power Query that allow you to run standard and recursive queries to transform data sets so that loading and creating visualizations is faster. You'll also learn how to extract, transform, and load different data sources, as well as how to detect and resolve problems related to the content of the data set to perform a correct analysis according to business needs.

       Duration:

      +200 Hours / 3-5 months

       Mode:

      In person
      Semi-presential
      On-line

       Prerequisites:

      Basic knowledge of computers and the Internet

      Official Certification

      Students gain official registration as technicians in a specific technology, which certifies them to practice their profession internationally. We certify our students worldwide.

      PL-300 Microsoft Power BI Data Analyst Certification

      DP-700 Microsoft Fabric Data Engineer Associate Certification

      Job opportunities

      The importance of data analysis tools is so great that they are necessary in a wide variety of fields, from the smallest website to the largest multinational. Training as a Business Analyst in Power BI (one of the most popular and widely used data visualization and analysis tools in the world) will mean acquiring a highly attractive and in-demand professional profile in today's job market, especially considering it is endorsed by a giant like Microsoft. The fact that data analysis and visualization are fundamental to the functioning of millions of companies around the world opens up a significant job market for Business Analysts.

      Through Cloud Talent The school connects you with more than 10,000 companies and generates job interviews and internships tailored to your professional profile. Additionally, the Cloud Talent Program gives you access to other complementary SAP certifications at no cost to enhance your qualifications.

      Syllabus

      Technical Training

      Basic concepts
      • Power BI Desktop work environment.
      • Obtaining and loading data using import and direct query mode.
      • Logical model and relationship management.
      • Data transformation.
      • Introduction to M language.
      • Advanced programming with DAX.
      • Advanced Power BI Reporting: Bookmarks, Navigation, and Templates.
      • Mobile view and web view.
      • Filters, groups and hierarchies.
      • Inclusion of R and Python scripts and visualizations.
      • Parameters, What-if and NQL.
      • Update settings.
      • Security, roles and collaborative environment.
      • Real-time data ingestion.
      • Data export.
      • Creating alarms.
      • Practical cases applied to the current use of Business Intelligence.

      Specific Training

      Level I: Concepts related to data and analysis

      1 - Data, Information and Knowledge Concepts
      • Data-Information-Knowledge Concepts
      • Transformation Model from Data to Information and Knowledge.
      • Transactional Systems and their Characteristics in Today's World.
      • Information Systems and their Characteristics in Today's World.
      • Strategic Direction and Useful Information.
      • Master Plan, Strategic and Operational.
      • The importance of data-driven decision-making and methods.
      • Information Systems in Businesses in Today's World.
      • Business Case (BC) and The Strategic Map.
      2 - Data, analysis and metrics
      • Real-world data and analytics
      • Learning to think about analytical problems
      • Examine the process by which data enables analysis and decision-making.
      • Present the value chain, from information action, which describes the path of events in the world, to business action
      • Explain the information lifecycle from real-world events to business actions.
      • Thinking about analytical problems in the business context
      • Recognize the characteristics of business analysis
      • Explain how systems capture and store data.
      3 - Business Intelligence Metrics
      • Basic introduction to Dashboards.
      • Metrics, indicators and KPIs (Main indicators).
      • Implementation of real, efficient and effective KPIs (SMART).
      • User Experience (UX).
      • Balanced Scorecard (BSC)
      • Operational Dashboards.
      • Taxonomy of DSS.
      • Types applied in Business Intelligence.
      • MIS, EIS and other BI tools.
      • Basic introduction to MIS and EIS.
      • MIS or Management Information Systems.
      • EIS or Executive Information System.
      • Other Business Intelligence tools.
      4 - How to deal with uncertainty and risk analysis

      • Risk analysis and Monte Carlo simulation.

      • Adding uncertainty to a spreadsheet model.

      • Definition of output variables and analysis of results.

      • Using historical data to model uncertainty.

      • Models with undetermined correlated variables.

      • Creation and interpretation of graphs.

      • Using average values versus simulation.

      Level II: Data Analysis Tools (I)

      1 - Power BI (I)

      • Introduction to Power BI: Origins and main features.

      • Power BI solution components and architecture.

      • Power BI Desktop work environment.

      • Obtaining and loading data using import and direct query mode.

      • Using Microsoft Dataverse

      • Logical model and relationship management

      2 - Power BI (II)
      • Data transformation.
      •  Deep query drilling in Power BI.
      • Introduction to M language.
      • Advanced programming with DAX.
      • Implement Time Intelligence using DAX.
      • Advanced Power BI Reporting: Bookmarks, Navigation, and Templates.
      • Mobile view and web view.
      • Filters, groups and hierarchies.
      • Inclusion of R and Python scripts and visualizations.
      • Parameters, What-if and NQL.
      • Creating tooltips.
      • Power BI Service environment: creating reports and dashboards.
      • Update settings.
      • Security, roles and collaborative environment.
      • Real-time data ingestion.
      • Data export.
      • Creating alarms.
      • Configuring Sync Slicers
      • Introduction to Power BI Report Server.
      • Practical cases applied to the current use of Business Intelligence.
      • Power BI Rest APIs
      • Advanced map display.
      • Using Play Axis of a Visualization
      • Advanced Power BI II reporting: Key Influencers, decomposition tree, and use of AI.
      • Flow and PowerBI integration.
      • Forms and PowerBI integration.
      • PowerApps and PowerBI integration.
      3 - Data Marts (DM), Data Warehouse (DWH) and ETL

      • Basic introduction to DM and DWH.

      • Data Marts

      • Data Warehouse

      • ETL process

      • Big Data vs Business Intelligence.

      • BI approaches with Big Data.

      4 - SQL, DDL and DML
      Relational Databases and SQL

      • Basic Introduction to Data Models.
      • Entity-Relationship Model and Its Use in Database Modeling.
      • Normal Standards Applicable in Operations and Information Systems.
      • Modeling in Operational Systems.
      • Modeling in Information Systems (Star and Snowflake).
      • Proper Use of the Model: Advantages and Differences.

      Data Definition Language (DDL) and Data Manipulation Language (DML)

      • Basic Introduction to SQL Language and Imperative Model.
      • Moving from the logical model to the physical model with DDL.
      • DDL and use with SQL Server.
      • DML and use with SQL Server.

      Structured Query Language (SQL)

      • SQL Under SQL Server
      • Basic SQL: Using SELECT, FROM, ORDER BY Clauses and General Functions.
      • Extract data from a relational database using SQL.
      • Cover basic SQL commands
      • Learn how to combine and stack data from different tables.
      • Learn how to extend the power of our queries using operators
      • Handle increased complexity using subqueries.
      • Advanced SQL: Use of WHERE, GROUP BY, HAVING Clauses.
      • Using Views in Business Intelligence.

      Level III: Data Analysis Tools (II) and Practical Business Analysis

      1 - Microstrategy in Business Intelligence

      • Introduction to Microstrategy: MicroStrategy Desktop.

      • Platform and Architecture.

      • Logical Model.

      • Configuring the Project (Architect and Developer).

      • Platform Administration.

      • Basic Microstrategy Reporting.

      • Basic Elements: Facts, Attributes, Hierarchies.

      • Formats, Sorts, Thresholds and Filters.

      • Generation of Simple Indicators and Navigation.

      • Advanced Microstrategy Reporting

      • Generation of Advanced Indicators and Thresholds.

      • Custom Groups and Dynamic Selections.

      • Including 3d.JS and R Elements in Microstrategy.

      • Practical Cases Applied to the Current Use of Business Intelligence.

      • Documents in Microstrategy.

      • Document Creation and Design.

      • Dataset Concept (Multiples).

      • Creating a Dashboard with a Widget.

      • Visual Insights. Custom Dashboards Made Simple.

      • Transaction Services: Insertion into Data Sources from Dashboards.

      • Security Filters for Users.

      • Microstrategy Oriented to Certification.

      2 - Analytical Marketing

      • Customer churn analysis. Customer acquisition analysis.

      • Web scrapping: Concept. Applications. How it works. Tools.

      • Customer Analytics: Customer-Centric Strategy. Customer Segmentation. Customer Value Management. Segmentation Exercises. Customer Analytics Case Studies

      • Analytical Marketing: Financial analytics. Marketing campaign analysis. E-commerce analysis. Marketing campaign dashboard. Offline ROPO analysis. Advanced digital analytics. Introduction to user experience. Design and UX analysis. User experience analysis and dashboard. Competitive analytics. Content analysis.

      • Email, SMS, postal marketing

      • Web & mobile analytics

      • Loyalty programs

      • Retail marketing.

      • Big Data and Business Intelligence

      3 - Decision making

      • Data exploration and reduction.

      • Cluster analysis.

      • Data reduction and unsupervised learning.

      • Data preparation and measurement of differences.

      • Hierarchical clustering, DB SCAN and k-Means.

      • Cluster analysis with Excel and Power BI.

      • Decision analysis

      • Given a business situation, apply an appropriate technique to identify the best solution alternatives.

      • Formulate and solve models for business problems that require yes/no decisions and logical constraints.

      • Create models that combine techniques and tools such as simulation and optimization.

      • Analyze and interpret results to make informed decisions.

      • Business problems with yes/no decisions

      • Formulation and solution of binary optimization problems.

      • Metaheuristic optimization

      • Probability and value-at-risk constraints.

      • Simulation optimization

      4 - Optimization

      • Develop a spreadsheet model for an optimization problem.

      • Use Excel to solve optimization models.

      • Interpret solutions and perform what-if analysis.

      • Hypothesis Analysis and Sensitivity Report

      • Evaluate scenarios and visualize results to gain actionable insights.

      • Digital marketing optimization application.

      Final Project
      • Course review.
      • Case study.
      Official Certification Seminar
      • Preparation of exam-type questions.

      Official certification

      Students gain access to the official registry of technicians in a specific technology, which qualifies them to practice their profession internationally.

      We certify our students throughout Spain and Latin America.

      Subsidized Training for Companies

      Cloud Training as an entity registered with code 16753 in the State Registry of Training Entities, Manages and teaches courses within the Company-Programmed Training initiative, Vocational Training for Employment, in accordance with the provisions of Law 30/2015, of September 9.

      Cloud Training helps you check your company's credit amount for this year, free of charge.