Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Practical PowerPivot & DAX Formulas for Excel 2010

Buy

PowerPivot: What a name! Or I should really say what’s in a name? Powerful Pivoting? Pivot-table for power users?

PowerPivot is a lot more than that. When I started the PowerPivot project back in 2007, along with Amir Netz (Microsoft BI Distinguished Engineer), the incubation project was called BI Sandbox. We had been looking at a problem that had often been raised to us by IT people over years of trying to implement a BI system with both Microsoft and non-Microsoft software. How could they set up an environment to enable their business users to build their own BI applications without needing assistance from IT? They wanted to focus on building the right data store for the enterprise, secure it, and ensure its quality, but also get out of the business of building one-off applications or reports for business users. And thus the BI Sandbox project was born. We would build an environment for users to play (sandbox) and do what they needed to do without needing to rely on IT folks to build it for them. Now IT would provide and provision the infrastructure and data source access, but they wouldn’t need to get involved in the building work for the application itself. This did make a lot of sense as business users understand their needs better than anyone else and often don’t have the patience or simply the luxury of time to wait for IT to queue this project behind all the other ones and build it three to six months later. So we had our vision and a real problem to solve. The next question was: how

250 + ready-to-use, powerful DAX formulas

Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot & DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide.

  • Build pivot tables and charts with PowerPivot for Excel
  • Import information from Access, Excel, data feeds, SQL Server, and other sources
  • Organize and format BI reports using the PowerPivot Field List
  • Write DAX formulas that filter, sort, average, and denormalize data
  • Construct complex DAX formulas from statistical, math, and date functions
  • Compare current and past performance using date and time intelligence
  • Handle non-additive numbers, non-numeric values, and running totals
  • Develop complete self-service and sharable BI solutions in a few minutes

Download the source code from www.mhprofessional.com/computingdownload

(HTML tags aren't allowed.)

Flexible Rails: Flex 3 on Rails 2
Flexible Rails: Flex 3 on Rails 2
Flexible Rails is a unique, application-based guide for using Ruby on Rails 2 and Adobe Flex 3 to build rich Internet applications (RIAs). It is not an exhaustive Ruby on Rails or Flex reference. Instead, it is an extensive tutorial in which the reader builds multiple iterations of an interesting RIA using Flex and Rails together.

...

Microsoft Exchange Server 2010 Inside Out
Microsoft Exchange Server 2010 Inside Out

Welcome to my tenth book covering the technology in Microsoft Exchange Server and its surrounding ecosystem. I seem to have been constantly writing about Exchange since before its introduction as version 4.0 in March 1996 in books and many articles printed in the redoubtable Windows IT Pro magazine (http://www.windowsitpro.com). All my...

Effective Akka
Effective Akka

Avoid common mistakes when building distributed, asynchronous, high-performance software with the Akka toolkit and runtime. With this concise guide, author Jamie Allen provides a collection of best practices based on several years of using the actor model. The book also includes examples of actor application types and two primary...


Philosophy's Higher Education
Philosophy's Higher Education
Few will disagree that philosophy is educational, or that at the root of philosophy lies
the struggle to understand ourselves, or, even, that this struggle is formative for us.
The real disagreement begins regarding the nature and import of this learning. In the
following pages I will challenge philosophical experience to recognise
...
What School Leaders Need to Know About Digital Technologies and Social Media
What School Leaders Need to Know About Digital Technologies and Social Media

Educational technology experts explain how to best integrate technology into K-12 schools, from blogs, wikis and podcasts to online learning, open-source courseware, and educational gaming to social networking, online mind-mapping, and using mobile phones.

TABLE OF CONTENTS
QoS Measurement and Evaluation of Telecommunications Quality of Service
QoS Measurement and Evaluation of Telecommunications Quality of Service
Most people know that quality of service (QoS) in telecommunications has grown in importance over the past decade. This is thanks to the new competitive environment which has followed as a direct result of privatization and de-regulation, forcing companies to increase the quality of their networks and services. Yet QoS means...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy