803 Business Analytics & Intelligence courses

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Data Entry Administrator Diploma with Transcription and Translation Diploma Welcome to the Data Entry Administrator Diploma with Transcription and Translation. This multifaceted course aims to provide you with comprehensive skills in data entry, alongside a specialised focus on Transcription and Translation. The demand for professionals who can provide accurate and fast transcription and translation services is rapidly growing. This course prepares you to meet that demand head-on. Learning Outcomes: Gain foundational knowledge in Transcription basics. Understand the role of context in Transcription. Attain skills to improve Transcription accuracy. Master the tools used in Transcription and Translation. Acquaint yourself with the translation industry's dynamics. Develop strategies for effective translation. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Data Entry Administrator Diploma with Transcription and Translation Diploma: Basics of Transcription: Begin your journey by understanding the fundamentals of Transcription, the cornerstone for developing specialised skills in the field. Context in Transcription: Here, you'll delve into the nuances of context, learning how it influences the accuracy and effectiveness of Transcription. Transcription Accuracy: Accuracy is paramount in Transcription. This module will equip you with techniques to enhance your Transcription accuracy. Tools in Transcription: This module introduces you to the tools integral to Transcription, from software to hardware, to optimise your workflow. Translation Industry in the Realm of Transcription: An essential overview of the translation industry, explaining how Transcription skills can be effectively utilised within it. Translation Strategies Complementing Transcription: Finalize your training by learning the best strategies for translating content in a manner that complements your Transcription skills.

Preparing for Digital Transformation: Virtual In-House Training Organizations today must keep pace with changing technology to stay abreast of the market demand. Keeping pace means a transformation of the entire organization into the digital age. This workshop presents the challenges, benefits, and pitfalls of digital transformation and how it will affect you, and how you can be better prepared and positioned for the upcoming digital transformation. The goal of this course is to enable you to become knowledgeable about the technologies behind a digital transformation in your organization and the driving forces compelling such a transformation. You will learn how to become engaged in the processes of transforming your organization digitally to meet with the growing demands of customers and clients What you will Learn Describe the impact that digital is making on the economy and on customer expectations Examine the nature and drivers of the digital transformation Evaluate new technologies such as Blockchain, Big Data, Artificial Intelligence, and other technologies and see how they work to bring about digital transformation Assess the impact of digital technologies on the current roles and positions in the organization Discuss both the demand that customers have for digital technologies and the impact the digital technologies have on the customer and its relationship with the organization Recognize the new technology trends in the digital transformation and what they mean to the future of the organization Identify how digital transformation will affect all roles and how to be prepared for the upcoming and continuing digital transformation Foundation Concepts Digital transformation versus automation Driving forces behind the digital transformation Learning from digital transformation successes Digital Transformation and Customer Orientation The Digital Customer Customer touch points and the customer journey Omnichannel concept Transform to the customer Digital Technologies and the Organization Relationship Management Big Data: The Basis for it All The Human Factor in Digital Transformations Risks of Digital Transformation Technology Trends Data and Business Analytics Other Major Trends Preview of Coming Attractions Pathway to Digital Transformation

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Overview   With the ever-increasing demand for Tableau in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Tableau may be.   Learning about Tableau or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Tableau. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Tableau is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by Compete High in this Diploma in Data Analytics In Tableau course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Diploma in Data Analytics In Tableau course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Diploma in Data Analytics In Tableau course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Tableau, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Tableau, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Tableau, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Diploma in Data Analytics In Tableau course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Module 01_ Data Analytics Data Analytics 00:00 Module 02_ Why Use Tableau for Data Analytics Why Use Tableau for Data Analytics 00:00 Module 03_ Getting Started With Tableau Getting Started With Tableau 00:00 Module 04_ Tableau Data Source (TDS) Tableau Data Source (TDS) 00:00 Module 05_ Tableau Worksheets Tableau Worksheets 00:00 Module 06_ Tableau Calculations Tableau Calculations 00:00 Module 07_ Tableau Sort _ Filters Tableau Sort _ Filters 00:00 Module 08_ Tableau Charts Tableau Charts 00:00 Module 09_ Tableau Advanced Tableau Advanced 00:00

Register on the Excel PowerQuery and PowerPivot today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Excel PowerQuery and PowerPivot is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Excel PowerQuery and PowerPivot Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Excel PowerQuery and PowerPivot, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Excel PowerQuery and PowerPivot pivot table power query power pivot - 1 00:09:00 pivot table power query power pivot - 2 00:01:00 pivot table power query power pivot - 3 00:02:00 pivot table power query power pivot - 4 00:03:00 pivot table power query power pivot - 5 00:01:00 pivot table power query power pivot - 6 00:04:00 pivot table power query power pivot - 7 00:08:00 pivot table power query power pivot - 8 00:05:00 pivot table power query power pivot - 9 00:03:00 pivot table power query power pivot - 10 00:04:00 pivot table power query power pivot - 11 00:04:00 pivot table power query power pivot - 12 00:02:00 pivot table power query power pivot - 13 00:03:00 pivot table power query power pivot - 14 00:05:00 pivot table power query power pivot - 15 00:02:00 pivot table power query power pivot - 16 00:03:00 pivot table power query power pivot - 17 00:03:00 pivot table power query power pivot - 18 00:08:00 pivot table power query power pivot - 19 00:02:00 pivot table power query power pivot - 20 00:04:00 pivot table power query power pivot - 21 00:05:00 pivot table power query power pivot - 22 00:09:00 pivot table power query power pivot - 23 00:04:00 pivot table power query power pivot - 24 00:03:00 pivot table power query power pivot - 25 00:04:00 pivot table power query power pivot - 26 00:09:00 Resources Resources - Excel PowerQuery And PowerPivot 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Overview This comprehensive course on Business Analystics for Beginners Using SASS will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Analystics for Beginners Using SASS comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Analystics for Beginners Using SASS. It is available to all students, of all academic backgrounds. Requirements Our Business Analystics for Beginners Using SASS is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 73 lectures • 08:10:00 total length •SAS Introduction: 00:07:00 •Introduction to SAS Program: 00:05:00 •Read SAS Dataset: 00:09:00 •Practice Read Dataset: 00:08:00 •Practical Example on Read Dataset: 00:02:00 •Introduction to SAS Dataset: 00:12:00 •SAS Dataset Practical Example: 00:07:00 •SAS Dataset Practical Program: 00:06:00 •DateValue: 00:03:00 •SAS Formats Part 1: 00:13:00 •SAS Formats Part 2: 00:09:00 •Reading Excel Worksheets: 00:05:00 •Reading Excel Worksheet Example: 00:11:00 •Date Format Example: 00:06:00 •Raw Data File Standard Part 1: 00:09:00 •Raw Data File Standard Part 2: 00:08:00 •Raw Data File Standard Example: 00:06:00 •Raw Data File Non Standard: 00:07:00 •Raw Data File Non Standard Example: 00:06:00 •Length Statement: 00:02:00 •Compilation Execution: 00:04:00 •Heading: 00:01:00 •Dataerrors: 00:05:00 •Data Errorsz Example: 00:03:00 •Validate Data Procfreq: 00:05:00 •Validate Data Procpront: 00:07:00 •Validate Data Peocmeans: 00:05:00 •Dat Constant: 00:07:00 •Assignment Statement: 00:09:00 •If Then Statement: 00:09:00 •If Then Do End Statement: 00:09:00 •Diff Where and If Statement: 00:02:00 •Keep Drop: 00:08:00 •Keep Drop Example: 00:04:00 •Append: 00:09:00 •Append Examples part 1: 00:09:00 •Append Examples part 2: 00:07:00 •Concatenate: 00:12:00 •Merge: 00:06:00 •Merge One to One: 00:07:00 •Merge One to Many: 00:04:00 •Merge Non Match: 00:04:00 •Global Statements: 00:09:00 •Global Statements Examples Part 1: 00:08:00 •Global Statements Examples Part 2: 00:06:00 •Title n Foot Note: 00:05:00 •Title n Foot Note Example: 00:08:00 •By Statement: 00:08:00 •Multiple Where Stament: 00:03:00 •ODS: 00:07:00 •ODS Example: 00:04:00 •Sas Date Function: 00:10:00 •Sas Date Function Example: 00:08:00 •Sas Functions Part 1: 00:10:00 •Sas Functions Part 2: 00:08:00 •Sas Functions: 00:07:00 •Sas Functions Example Part 1: 00:07:00 •Sas Functions Example Part 2: 00:09:00 •Multiple SAS Datasets Part 1: 00:05:00 •Multiple SAS Datasets Part 2: 00:02:00 •Multiple SAS Datasets Example: 00:09:00 •Select Group: 00:09:00 •Select Group Example: 00:08:00 •Do Loop Part 1: 00:07:00 •Do Loop Part 2: 00:06:00 •Do Loop Example: 00:07:00 •Array Part 1: 00:05:00 •Array Part 2: 00:08:00 •Array DoLoop: 00:06:00 •ArrayTemp: 00:05:00 •Array Example: 00:10:00 •Sas Statement Part 1: 00:04:00 •Sas Statement Part 2: 00:05:00

Preparing for Digital Transformation (On-Demand) The goal of this course is to enable you to become knowledgeable about the technologies behind a digital transformation in your organization and the driving forces compelling such a transformation. You will learn how to become engaged in the processes of transforming your organization digitally to meet with the growing demands of customers and clients. Organizations today must keep pace with changing technology to stay abreast of the market demand. Keeping pace means a transformation of the entire organization into the digital age. This workshop presents the challenges, benefits, and pitfalls of digital transformation and how it will affect you, and how you can be better prepared and positioned for the upcoming digital transformation. You will learn how to become engaged in the processes of transforming your organization digitally to meet with the growing demands of customers and clients. What you will Learn Describe the impact that digital is making on the economy and on customer expectations Examine the nature and drivers of the digital transformation Evaluate new technologies such as Blockchain, Big Data, Artificial Intelligence, and other technologies and see how they work to bring about digital transformation Assess the impact of digital technologies on the current roles and positions in the organization Discuss both the demand that customers have for digital technologies and the impact the digital technologies have on the customer and its relationship with the organization Recognize the new technology trends in the digital transformation and what they mean to the future of the organization Identify how digital transformation will affect all roles and how to be prepared for the upcoming and continuing digital transformation Getting Started Foundation Concepts Digital transformation versus automation Driving forces behind the digital transformation Learning from digital transformation successes Digital Transformation and Customer Orientation The Digital Customer Customer touch points and the customer journey Omnichannel concept Transform to the customer Digital Technologies and the Organization Relationship Management Big Data: The Basis for it All The Human Factor in Digital Transformations Risks of Digital Transformation Technology Trends Data and Business Analytics Other Major Trends Preview of Coming Attractions Pathway to Digital Transformation Summary and Next Steps

Duration 3 Days 18 CPD hours This course is intended for Analyst Developer End User Implementer Overview Schedule and Burst Reports Perform Translations Create Reports Integrated With Oracle BI EE Administer BI Publisher Server Describe BI Publisher Technology and Architecture Create reports from OBI EE data sources Create and Modify Data Models Create RTF Templates by Using Template Builder Explore and Use the Form Field Method for Creating RTF Templates Create Layouts by Using the Layout Editor This Oracle BI Publisher 12c training will help you build a foundation of understanding how to best leverage this solution. Through Classroom Training or Live Virtual Class Training, you'll learn the ins and outs of how to use this solution. BI Publisher Technology and Architecture Functional Components Layout Templates Multitier Architecture Enterprise Server Architecture and Performance and Scalability Document Generation Process and Output Formats Supported Data Sources Bursting Overview Internationalization and Language Support Getting Started with BI Publisher Logging In, the Home Page, and Global Header, and Setting Account Preferences Viewing Reports Managing Repository Objects Managing Favorites Using Create Report wizard to Create Reports Selecting Data: Data Model, Spreadsheet, and BI Subject Area Configuring Report Properties Using the Data Model Editor Exploring the Schemas Used in the Course Exploring the Data Model Editor UI and the Supported Data Sources Creating a Private Data Source Creating a Simple Data Model based on a SQL Query Data Set Using Query Builder to Build a Query Viewing Data and Saving Sample Data Sets Adding Parameters and LOVs to the Query Configuring Parameter Settings and Viewing Reports with Parameters Working with Layout Editor Opening the Layout Editor and Navigating the Layout Editor UI Creating a Layout by Using a Basic Template Inserting a Layout Grid Adding a Table, Formatting Columns, Defining Sorts and Groups, and Applying Conditional Formats Inserting and Editing Charts, and Converting Charts to a Pivot Tables Adding Repeating Sections, Text Items, and Images Working with Lists, Gauges and Pivot Tables Creating Boilerplates Using Template Builder to Create RTF Templates Using the BI Publisher Menu Bar Creating an RTF Template from a Sample, Changing Field Properties, and Previewing Table Data Adding a Chart to an RTF Template Designing an RTF Template for a BI Publisher Report Creating a BI Publisher Report by Using Template Builder in Online Mode Exploring the Basic and Form Field Methods Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting BI Publisher Server: Administration and Security Describing the Administration Page Creating the JDBC Connections Setting, Viewing, and Updating Data Sources Describing the Security Model for BI Publisher and Oracle Fusion Middleware Describing Groups, Users, Roles, and Permissions Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS Describing and Configuring BI Publisher Scheduler Integrating with Oracle BI Presentation Services and Oracle Endeca Server Scheduling and Bursting Reports Scheduling and Describing a Report Job and Related Options Managing and Viewing a Report Job Viewing Report Job History Scheduling a Report with Trigger Describing Bursting Adding a Bursting Definition to a Data Model Scheduling a Bursting Job Integrating BI Publisher with Oracle BI Enterprise Edition Configuring Presentation Services Integration Navigating Oracle BI EE Creating a Report based on OBI EE Subject Area Creating a Data Model and Report based on a BI Server SQL Query Creating a Data Model and Report based on an Oracle BI Analysis Adding a BI Publisher Report to an Oracle BI EE Dashboard Creating Data Models and BI Publisher Reports Based on Other Data Sources Configuring Presentation Services Integration Describing the Web Services Data Source Describing the HTTP (XML/RSS Feed) Data Source Explaining Proxy Setting for Web Services and HTTP Data Sources Creating a BI Publisher Report based on an External Web Service Creating a BI Publisher Report based on an HTTP Data Set Creating a BI Publisher Report Based on XML File Creating a BI Publisher Report Based on CSV Data source Performing Translations Describing Translation Types Translating by Using the Localized Template Option Translating by Using the XLIFF Option Managing XLIFF Translations on BI Publisher Server Describing the Overall Translation Process Describing Catalog Translation Exporting and Importing the XLIFF for a Catalog Folder Additional course details: Nexus Humans Oracle BI Publisher 12c R1: Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle BI Publisher 12c R1: Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals. Overview ?Understand common Analysis Services solutions.?Understand version changes of SSAS from 2008-2014.?Understand Analysis Services installation and architecture.?Understand how to choose the right model.?Understand the Analysis Services tools available.?Understand the multidimensional model.?Utilize data sources and data source views.?Create a cube.?Understand and utilize dimensions.?Understand and utilize attributes.?Understand and utilize relationships.?Understand and utilize hierarchies.?Understand and utilize measures and measure groups.?Understand and utilize calculated members.?Understand and utilize perspectives.?Understand and utilize translations.?Browse perspectives and translations.?Understand and utilize deployment options.?Understand and utilize processing strategies.?Understand and utilize security.?Deploy a multidimensional model.?Understand the tabular model.?Create a tabular project.?Analyze the data using Microsoft Excel.?Create and configure calculated measures and calculated fields.?Backup and Restore. This course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. Course Overview Introduction Course Materials Facilities Prerequisites What We'll Be Discussing Lab 1: Course Overview Introduction to Microsoft SQL Server Analysis Services Common Analysis Services Solutions Version Changes of SSAS from 2008-2014 Analysis Services Installation and Architecture: One Product, Two Models Choosing the Right Model Analysis Services Tools Lab 1: Introduction to Microsoft SQL Server Analysis Services The Multidimensional Solution Understanding the Multidimensional Model Utilizing Data Sources and Data Source Views Creating a Cube Lab 1: The Multidimensional Solution Dissecting with Dimensions Developing Dimensions Utilizing Attributes Relating with Relationships Handling Hierarchies Lab 1: Dissecting with Dimensions Managing Measures Measures and Measure Groups Calculated Members Lab 1: Managing Measures Configuring Cube Options Understanding Perspectives Utilizing Translations Browsing Perspectives and Translations Lab 1: Configuring Cube Options Deploying Examining Deployment Options Processing Strategies Exploring Security Lab 1: Deploying The Tabular Solution Understanding the Tabular Model Creating a Tabular Project Deploying Browsing the Model Querying the Solution and Understanding DAX Maintaining and Optimizing Lab 1: The Tabular Solution