Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

PXL-Business 2018 --- informatica --- Excel --- business intelligence --- bigdata --- Power Pivot --- Datacommunicatie --- Informatica

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

DAX (Data Analysis Expressions) ist die Formelsprache für Power Pivot, PowerBI und Microsoft Analysis Services, um Datenmodelle zu erstellen. Dieses Buch gibt einen tiefen Einblick in DAX vom Einstieg bis in technische Details, um Code und Modelle zu optimieren. Es ist ein deduktives Lehrbuch, das auch als Referenzwerk zum Nachschlagen genutzt werden kann. Die Autoren sind bekannte DAX-Experten, die unzählige Artikel und Blogposts geschrieben haben und seit Jahren Anwendern und Entwicklern dabei helfen, DAX zu lernen.

Datenanalyse --- Programmierung --- Excel --- Datenbanken --- Referenz --- Datenmodelle --- PowerBI --- Data Analysis Expressions --- Formelsprache --- Microsoft Analysis Services --- Power Pivot --- Tabular --- Microsoft PowerPivot (Computer file) --- Microsoft Excel (Computer file) --- SQL server.

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft’s Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven maps. While Beginning Big Data with Power BI and Excel 2013 covers prominent tools such as Hadoop and the NoSQL databases, it recognizes that most small and medium-sized businesses don’t have the Big Data processing needs of a Netflix, Target, or Facebook. Instead, it shows how to import data and use the self-service analytics available in Excel with Power BI. As you’ll see through the book’s numerous case examples, these tools—which you already know how to use—can perform many of the same functions as the higher-end Apache tools many people believe are required to carry out in Big Data projects. Through instruction, insight, advice, and case studies, Beginning Big Data with Power BI and Excel 2013 will show you how to: Import and mash up data from web pages, SQL and NoSQL databases, the Azure Marketplace and other sources. Tap into the analytical power of PivotTables and PivotCharts and develop relational data models to track trends and make predictions based on a wide range of data. Understand basic statistics and use Excel with PowerBI to do sophisticated statistical analysis—including identifying trends and correlations. Use SQL within Excel to do sophisticated queries across multiple tables, including NoSQL databases. Create complex formulas to solve real-world business problems using Data Analysis Expressions (DAX).

Computer Science --- Engineering & Applied Sciences --- Big data. --- Business --- Computer science. --- Data processing. --- Microsoft Excel (Computer file) --- Microsoft PowerPivot (Computer file) --- Informatics --- Electronic data processing --- Data sets, Large --- Large data sets --- Microsoft Power Pivot (Computer file) --- PowerPivot (Computer file) --- Microsoft Excel for the Macintosh --- Microsoft Excel for Windows --- Excel (Computer file) --- Excel for Windows --- Microsoft Excel for Windows 95 --- Excel 97 --- Microsoft Excel 97 for Windows --- Excel 2000 --- Excel 2000 for Windows 95 --- Microsoft Excel 2002 --- Microsoft Office Excel 2003 --- Excel 2003 --- Microsoft Excel 2007 --- Excel 2007 --- Excel 2010 --- Microsoft Excel 2013 --- Excel 2013 --- Computer Science. --- Computer Science, general. --- Science --- Microsoft software. --- Microsoft .NET Framework. --- Information systems. --- Microsoft and .NET. --- Information Systems and Communication Service. --- Computer software --- Microsoft Excel 2016 --- Excel 2016 --- Computers. --- Automatic computers --- Automatic data processors --- Computer hardware --- Computing machines (Computers) --- Electronic brains --- Electronic calculating-machines --- Electronic computers --- Hardware, Computer --- Computer systems --- Cybernetics --- Machine theory --- Calculators --- Cyberspace

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files. PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world. Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence.

Business intelligence -- Computer programs. --- Microsoft Excel (Computer file). --- Microsoft SharePoint (Electronic resource). --- SQL server. --- Business intelligence --- Engineering & Applied Sciences --- Commerce --- Business & Economics --- Computer Science --- Marketing & Sales --- Computer programs --- Information Technology --- Computer Science (Hardware & Networks) --- General and Others --- Business intelligence. --- Microsoft software. --- Business espionage --- Competitive intelligence --- Corporate intelligence --- Economic espionage --- Espionage, Business --- Espionage, Economic --- Espionage, Industrial --- Industrial espionage --- Intelligence, Business --- Intelligence, Corporate --- Computer science. --- Computer Science. --- Computer Science, general. --- Informatics --- Science --- Microsoft Excel (Computer file) --- Microsoft SharePoint (Electronic resource) --- Microsoft Share point (Electronic resource) --- SharePoint (Electronic resource) --- Microsoft Excel for the Macintosh --- Microsoft Excel for Windows --- Excel (Computer file) --- Excel for Windows --- Microsoft Excel for Windows 95 --- Excel 97 --- Microsoft Excel 97 for Windows --- Excel 2000 --- Excel 2000 for Windows 95 --- Microsoft Excel 2002 --- Microsoft Office Excel 2003 --- Excel 2003 --- Microsoft Excel 2007 --- Excel 2007 --- Excel 2010 --- Microsoft Excel 2013 --- Excel 2013 --- Computer software --- Business ethics --- Competition, Unfair --- Industrial management --- Confidential business information --- Microsoft .NET Framework. --- Information systems. --- Microsoft and .NET. --- Information Systems and Communication Service. --- Microsoft Excel 2016 --- Excel 2016 --- Computers. --- Automatic computers --- Automatic data processors --- Computer hardware --- Computing machines (Computers) --- Electronic brains --- Electronic calculating-machines --- Electronic computers --- Hardware, Computer --- Computer systems --- Cybernetics --- Machine theory --- Calculators --- Cyberspace --- Microsoft PowerPivot (Computer file) --- Microsoft Power Pivot (Computer file) --- PowerPivot (Computer file)