Success Story TopPharm TopPharm offers industry partners a secure KPIaaS platform for accessing sales data, based on Qlik & iVIEW and hosted in the Swiss BI Cloud.
Success Story FRED Financial Data AG FRED Financial Data AG ensures data quality for asset managers and optimizes processes through migration to Qlik Sense.
Success Story TopPharm TopPharm offers industry partners a secure KPIaaS platform for accessing sales data, based on Qlik & iVIEW and hosted in the Swiss BI Cloud.
Success Story FRED Financial Data AG FRED Financial Data AG ensures data quality for asset managers and optimizes processes through migration to Qlik Sense.
Microsoft Power BI Business Analyst Training Practice-oriented training on data analysis and visualisation with Microsoft Power BI. Learn the basics, architecture and practical application in scenarios. Training content Request form Our Expertise MICROSOFT POWER BI BUSINESS ANALYST TRAINING Business analysts have to identify potential and weak points in companies and develop solutions. Our training imparts the right skills for any level of knowledge and any industry in order to use power BI to do so professionally. COURSE DESCRIPTION The Power BI Business Analyst training is a scenario-based course that provides basic knowledge of the entire functional scope of Power BI for business users or data analysts. During two days of training, participants will be introduced to the architecture as well as the complete structure of Power BI. In addition, the various methods and best practices that meet the business and technical requirements for modelling, visualising and analysing data with Power BI will be discussed. The course demonstrates how to access and process data from a range of data sources. Different display options for data visualisation will be presented and you will learn how to manage and deploy reports and dashboards for sharing and content distribution. An outlook on the latest and future functionalities of Power BI, practical examples, design concepts and some in-depth topics round off the training. The training material will be provided. CONTENTS Introduction to Power BI. Understanding and using Power BI Service. Connecting and transforming data from different data sources. Defining business rules and KPIs. Analysing data with powerful, interactive visualisation tools. Creating engaging reports. Sharing reports with your team and business partners and publishing them on the web. Writing DAX formulas. Defining calculated tables, columns and metrics. Learning best practices in data preparation and visualisation. Providing reports for mobile application. Getting to know the latest and future functionalities. Book your training in our E-Shop COURSE REQUIREMENTS Knowledge of Excel Power BI Desktop Data affinity is an advantage Knowledge of working with relational data TECHNICAL REQUIREMENTS Microsoft Power BI Desktop (free download) PC or laptop with a Windows operating system TARGET GROUP Business Users Business Analysts Data Analysts Data Architects LANGUAGE German English on request TRAINING MODALITIES Classroom / Virtual / On-site Public / Private (for groups of up to 10 persons) DURATION 2 days DETAILED PROGRAM FOR MICROSOFT POWER BI BUSINESS ANALYST TRAINING FIRST STEPS WITH MICROSOFT DATA ANALYTICS Data analysis and Microsoft First steps with Power BI RETRIEVING DATA IN POWER BI Preparing data CLEANING, TRANSFORMING AND LOADING DATA INTO POWER BI Shaping data Loading data DESIGNING A DATA MODEL IN POWER BI Introduction to data modelling Working with tables Dimensions and hierarchies Creating model relationships Configuring tables and column properties Creating hierarchies CREATING MODEL CALCULATIONS WITH DAX IN POWER BI Introduction to Power DAX Creating calculated tables Creating calculated columns Creating key figures CREATING REPORTS IN POWER BI Designing a report Creating and configuring a sync slicer Creating a drill-through page The use of conditional formatting Creating and using bookmarks Designing a report Configuring visual fields and format properties CREATING DASHBOARDS IN POWER BI Creating a dashboard IDENTIFYING PATTERNS AND TRENDS IN POWER BI Advanced analytics Data insights through AI visuals Use the visual to predict values REQUEST FOR MICROSOFT POWER BI TRAINING Please fill out the form and send us your non-binding enquiry about our Microsoft Power BI training courses. Dates and costs on request. You must have JavaScript enabled to use this form. Salutation - Select -Mr.Mrs. First name Last name Company Your Email Phone Training name - Select -Business AnalystData Analyst PL-300T00Customized Training type - Select -Classroom (Public)On-Site (Private) Number participants Message ✔ Privacy Policy I hereby agree to the privacy policy. * Mandatory field to answer your request Power BI Desktop Power BI Desktop is a free Microsoft app that you install on your local computer. It enables you to connect to many different data sources to transform and visualise them in reports and dashboards. Learn more about Power BI Our Microsoft Power BI Expertise CHOOSE THE RIGHT TRAINING PARTNER! LONG-STANDING MICROSOFT PARTNER CERTIFIED POWER BI DATA ANALYSTS MICROSOFT CERTIFIED TRAINER 2023-2024 You are in good hands at the Informatec Data Intelligence Academy. Data is our passion and turning people into data experts is our vocation. In addition to Power BI training, as a Qlik Authorised Training Partner we offer official Qlik training courses. Visit our Qlik Academy The locations The training courses take place at the COOP Tagungszentrum Muttenz (Basel-Land) or at the Ambassador House Zurich, where participants find the perfect setting for their training. COOP convention center Muttenz (Basel Area) 0 1 2 3 4 Ideal location: 15 minutes’ ride from Basel city centre (tram line 14, stop Freidorf), a few kilometers from the highway, parking available First-class infrastructure: spacious premises, innovative working environment with modern conference facilities, all rooms with natural daylight, soundproof doors and air conditioning Pleasant atmosphere: idyllic park, restaurant with market-fresh cuisine, professional service team Address: COOP Tagungszentrum, Seminarstrasse 12-22, 4132 Muttenz Route Ambassador House Zürich 0 1 2 3 In the heart of Zurich North: The district offers a modern residential environment, many new restaurants, numerous shopping opportunities and a recreation area with its own lake. The Ambassador House is easily accessible by car and public transport. Underground parking available. Hotspot for seminars: With various meeting rooms, conference rooms and auditoriums. State-of-the-art technology, first-class facilities, catering of choice and extensive services. Hospitality at a high level: In the Ambassador House and Spaces, experience the flair of the coworking area and move around in a modern city island! Adress: Ambassador House, Thurgauerstrasse101, 8152 Opfikon Route